﻿<!DOCTYPE html>
<html>
  <head>
    <title>create/edit-job</title>
    <meta http-equiv="X-UA-Compatible" content="IE=edge"/>
    <meta http-equiv="content-type" content="text/html; charset=utf-8"/>
    <link href="resources/css/axure_rp_page.css" type="text/css" rel="stylesheet"/>
    <link href="data/styles.css" type="text/css" rel="stylesheet"/>
    <link href="files/create_edit-job/styles.css" type="text/css" rel="stylesheet"/>
    <script src="resources/scripts/jquery-3.2.1.min.js"></script>
    <script src="resources/scripts/axure/axQuery.js"></script>
    <script src="resources/scripts/axure/globals.js"></script>
    <script src="resources/scripts/axutils.js"></script>
    <script src="resources/scripts/axure/annotation.js"></script>
    <script src="resources/scripts/axure/axQuery.std.js"></script>
    <script src="resources/scripts/axure/doc.js"></script>
    <script src="resources/scripts/messagecenter.js"></script>
    <script src="resources/scripts/axure/events.js"></script>
    <script src="resources/scripts/axure/recording.js"></script>
    <script src="resources/scripts/axure/action.js"></script>
    <script src="resources/scripts/axure/expr.js"></script>
    <script src="resources/scripts/axure/geometry.js"></script>
    <script src="resources/scripts/axure/flyout.js"></script>
    <script src="resources/scripts/axure/model.js"></script>
    <script src="resources/scripts/axure/repeater.js"></script>
    <script src="resources/scripts/axure/sto.js"></script>
    <script src="resources/scripts/axure/utils.temp.js"></script>
    <script src="resources/scripts/axure/variables.js"></script>
    <script src="resources/scripts/axure/drag.js"></script>
    <script src="resources/scripts/axure/move.js"></script>
    <script src="resources/scripts/axure/visibility.js"></script>
    <script src="resources/scripts/axure/style.js"></script>
    <script src="resources/scripts/axure/adaptive.js"></script>
    <script src="resources/scripts/axure/tree.js"></script>
    <script src="resources/scripts/axure/init.temp.js"></script>
    <script src="resources/scripts/axure/legacy.js"></script>
    <script src="resources/scripts/axure/viewer.js"></script>
    <script src="resources/scripts/axure/math.js"></script>
    <script src="resources/scripts/axure/jquery.nicescroll.min.js"></script>
    <script src="data/document.js"></script>
    <script src="files/create_edit-job/data.js"></script>
    <script type="text/javascript">
      $axure.utils.getTransparentGifPath = function() { return 'resources/images/transparent.gif'; };
      $axure.utils.getOtherPath = function() { return 'resources/Other.html'; };
      $axure.utils.getReloadPath = function() { return 'resources/reload.html'; };
    </script>
  </head>
  <body>
    <div id="base" class="">

      <!-- Unnamed (Rectangle) -->
      <div id="u58" class="ax_default box_1">
        <div id="u58_div" class=""></div>
        <div id="u58_text" class="text " style="display:none; visibility: hidden">
          <p></p>
        </div>
      </div>

      <!-- Unnamed (Rectangle) -->
      <div id="u59" class="ax_default box_1">
        <div id="u59_div" class=""></div>
        <div id="u59_text" class="text " style="display:none; visibility: hidden">
          <p></p>
        </div>
      </div>

      <!-- Unnamed (Rectangle) -->
      <div id="u60" class="ax_default heading_1">
        <div id="u60_div" class=""></div>
        <div id="u60_text" class="text ">
          <p><span style="font-family:'Arial-BoldMT', 'Arial Bold', 'Arial', sans-serif;font-weight:700;">Flink</span><span style="font-family:'PingFangSC-Semibold', 'PingFang SC Semibold', 'PingFang SC', sans-serif;font-weight:650;">控制台</span></p>
        </div>
      </div>

      <!-- Unnamed (Rectangle) -->
      <div id="u61" class="ax_default heading_2">
        <div id="u61_div" class=""></div>
        <div id="u61_text" class="text ">
          <p><span style="font-family:'PingFangSC-Semibold', 'PingFang SC Semibold', 'PingFang SC', sans-serif;font-weight:650;">欢迎您，</span><span style="font-family:'Arial-BoldMT', 'Arial Bold', 'Arial', sans-serif;font-weight:700;">xxx</span></p>
        </div>
      </div>

      <!-- Unnamed (Rectangle) -->
      <div id="u62" class="ax_default heading_2">
        <div id="u62_div" class=""></div>
        <div id="u62_text" class="text ">
          <p><span>退出</span></p>
        </div>
      </div>

      <!-- Unnamed (Rectangle) -->
      <div id="u63" class="ax_default box_1">
        <div id="u63_div" class=""></div>
        <div id="u63_text" class="text " style="display:none; visibility: hidden">
          <p></p>
        </div>
      </div>

      <!-- Unnamed (Rectangle) -->
      <div id="u64" class="ax_default box_1">
        <div id="u64_div" class=""></div>
        <div id="u64_text" class="text ">
          <p><span>首页</span></p>
        </div>
      </div>

      <!-- Unnamed (Rectangle) -->
      <div id="u65" class="ax_default box_1">
        <div id="u65_div" class=""></div>
        <div id="u65_text" class="text ">
          <p><span>任务列表</span></p>
        </div>
      </div>

      <!-- Unnamed (Shape) -->
      <div id="u66" class="ax_default box_1">
        <img id="u66_img" class="img " src="images/front-page/u8.svg"/>
        <div id="u66_text" class="text ">
          <p><span>新建任务</span></p>
        </div>
      </div>

      <!-- Unnamed (Rectangle) -->
      <div id="u67" class="ax_default box_1">
        <div id="u67_div" class=""></div>
        <div id="u67_text" class="text ">
          <p><span>数据流概览</span></p>
        </div>
      </div>

      <!-- Unnamed (Text Field) -->
      <div id="u68" class="ax_default text_field">
        <div id="u68_div" class=""></div>
        <input id="u68_input" type="text" value="请输入任务名" class="u68_input"/>
      </div>

      <!-- Unnamed (Shape) -->
      <div id="u69" class="ax_default primary_button">
        <img id="u69_img" class="img " src="images/create_edit-job/u69.svg"/>
        <div id="u69_text" class="text ">
          <p><span>格式化</span></p>
        </div>
      </div>

      <!-- Unnamed (Line) -->
      <div id="u70" class="ax_default line">
        <img id="u70_img" class="img " src="images/job-list/u47.svg"/>
        <div id="u70_text" class="text " style="display:none; visibility: hidden">
          <p></p>
        </div>
      </div>

      <!-- Unnamed (Shape) -->
      <div id="u71" class="ax_default primary_button">
        <img id="u71_img" class="img " src="images/create_edit-job/u71.svg"/>
        <div id="u71_text" class="text ">
          <p><span>部署</span></p>
        </div>
      </div>

      <!-- Unnamed (Shape) -->
      <div id="u72" class="ax_default primary_button">
        <img id="u72_img" class="img " src="images/create_edit-job/u72.svg"/>
        <div id="u72_text" class="text ">
          <p><span>保存</span></p>
        </div>
      </div>

      <!-- Unnamed (Text Area) -->
      <div id="u73" class="ax_default text_area">
        <div id="u73_div" class=""></div>
        <textarea id="u73_input" class="u73_input">CREATE TABLE MyTable1(
&nbsp; &nbsp; name varchar,
&nbsp; &nbsp; meal_type int,
&nbsp; &nbsp; PRIMARY KEY(name)
 )WITH(
&nbsp; &nbsp; type ='kafka',
&nbsp; &nbsp; bootstrapServers ='localhost:9092',
&nbsp; &nbsp; zookeeperQuorum ='localhost:2181',
&nbsp; &nbsp; offsetReset ='latest',
&nbsp; &nbsp; topic ='source3',
&nbsp; &nbsp; timezone='Asia/Shanghai',
&nbsp; &nbsp; updateMode ='append',
&nbsp; &nbsp; enableKeyPartitions ='false',
&nbsp; &nbsp; topicIsPattern ='false',
&nbsp; &nbsp; parallelism ='1'
 );

 CREATE TABLE MyTable2(
&nbsp; &nbsp; NAME varchar,
&nbsp; &nbsp; AGE int,
&nbsp; &nbsp; GENDER int,
&nbsp; &nbsp; PERIOD FOR SYSTEM_TIME
 )WITH(
&nbsp; &nbsp; type ='dameng',
&nbsp; &nbsp; url =' jdbc:dm://10.10.133.220:5236/CSSFLINK',
&nbsp; &nbsp; userName = 'CSSBASE',
&nbsp; &nbsp; password = '1234567890',
&nbsp; &nbsp; tableName = 'PERSON',
&nbsp; &nbsp; schema = 'CSSFLINK',
&nbsp; &nbsp; parallelism = '1',
&nbsp; &nbsp; partitionedJoin='false'
 );

CREATE TABLE MyResult(
&nbsp; &nbsp; NAME varchar,
&nbsp; &nbsp; AGE int,
&nbsp; &nbsp; GENDER int,
&nbsp; &nbsp; meal_type int
 )WITH(
&nbsp; &nbsp; type ='kafka',
&nbsp; &nbsp; bootstrapServers ='localhost:9092',
&nbsp; &nbsp; zookeeperQuorum ='localhost:2181',
&nbsp; &nbsp; offsetReset ='latest',
&nbsp; &nbsp; topic ='source4',
&nbsp; &nbsp; timezone='Asia/Shanghai',
&nbsp; &nbsp; updateMode ='append',
&nbsp; &nbsp; enableKeyPartitions ='false',
&nbsp; &nbsp; topicIsPattern ='false',
&nbsp; &nbsp; parallelism ='1'
 );


insert
into
&nbsp; &nbsp; MyResult
&nbsp; &nbsp; select
&nbsp; &nbsp; &nbsp; &nbsp; MyTable2.NAME,MyTable2.AGE,MyTable2.GENDER,MyTable1.meal_type
&nbsp; &nbsp; from
&nbsp; &nbsp; &nbsp; &nbsp; MyTable1 left join MyTable2
&nbsp; &nbsp; &nbsp; &nbsp; on MyTable1.name = MyTable2.NAME</textarea>
      </div>

      <!-- Unnamed (Rectangle) -->
      <div id="u74" class="ax_default heading_1">
        <div id="u74_div" class=""></div>
        <div id="u74_text" class="text ">
          <p><span style="font-family:'Arial-BoldMT', 'Arial Bold', 'Arial', sans-serif;font-weight:700;">Flink SQL</span><span style="font-family:'PingFangSC-Semibold', 'PingFang SC Semibold', 'PingFang SC', sans-serif;font-weight:650;">工具</span></p>
        </div>
      </div>

      <!-- Unnamed (Image) -->
      <div id="u75" class="ax_default image">
        <img id="u75_img" class="img " src="images/front-page/u15.png"/>
        <div id="u75_text" class="text " style="display:none; visibility: hidden">
          <p></p>
        </div>
      </div>

      <!-- Unnamed (Image) -->
      <div id="u76" class="ax_default image">
        <img id="u76_img" class="img " src="images/create_edit-job/u76.png"/>
        <div id="u76_text" class="text " style="display:none; visibility: hidden">
          <p></p>
        </div>
      </div>

      <!-- Unnamed (Rectangle) -->
      <div id="u77" class="ax_default box_2">
        <div id="u77_div" class=""></div>
        <div id="u77_text" class="text ">
          <p><span>error</span></p>
        </div>
      </div>

      <!-- Unnamed (Rectangle) -->
      <div id="u78" class="ax_default box_1 ax_default_hidden" style="display:none; visibility: hidden">
        <div id="u78_div" class=""></div>
        <div id="u78_text" class="text ">
          <p style="font-size:20px;text-align:center;"><span style="font-family:'ArialMT', 'Arial', sans-serif;font-size:30px;">SQL</span><span style="font-family:'PingFangSC-Regular', 'PingFang SC', sans-serif;font-size:30px;">帮助</span></p><p style="font-size:20px;text-align:left;"><span style="font-family:'PingFangSC-Regular', 'PingFang SC', sans-serif;font-size:25px;color:#EC808D;">示例：Kafka Table写法</span></p><p style="font-size:20px;text-align:left;"><span style="font-family:'PingFangSC-Regular', 'PingFang SC', sans-serif;">CREATE TABLE MyTable(</span></p><p style="font-size:20px;text-align:left;"><span style="font-family:'PingFangSC-Regular', 'PingFang SC', sans-serif;">&nbsp;&nbsp;&nbsp; name varchar,</span></p><p style="font-size:20px;text-align:left;"><span style="font-family:'PingFangSC-Regular', 'PingFang SC', sans-serif;">&nbsp;&nbsp;&nbsp; id int</span></p><p style="font-size:20px;text-align:left;"><span style="font-family:'PingFangSC-Regular', 'PingFang SC', sans-serif;">&nbsp;)WITH(</span></p><p style="font-size:20px;text-align:left;"><span style="font-family:'PingFangSC-Regular', 'PingFang SC', sans-serif;">&nbsp;&nbsp;&nbsp; type ='kafka',</span></p><p style="font-size:20px;text-align:left;"><span style="font-family:'PingFangSC-Regular', 'PingFang SC', sans-serif;">&nbsp;&nbsp;&nbsp; bootstrapServers ='localhost:9092',</span></p><p style="font-size:20px;text-align:left;"><span style="font-family:'PingFangSC-Regular', 'PingFang SC', sans-serif;">&nbsp;&nbsp;&nbsp; zookeeperQuorum ='localhost:2181',</span></p><p style="font-size:20px;text-align:left;"><span style="font-family:'PingFangSC-Regular', 'PingFang SC', sans-serif;">&nbsp;&nbsp;&nbsp; offsetReset ='latest',</span></p><p style="font-size:20px;text-align:left;"><span style="font-family:'PingFangSC-Regular', 'PingFang SC', sans-serif;">&nbsp;&nbsp;&nbsp; topic ='source3',</span></p><p style="font-size:20px;text-align:left;"><span style="font-family:'PingFangSC-Regular', 'PingFang SC', sans-serif;">&nbsp;&nbsp;&nbsp; timezone='Asia/Shanghai',</span></p><p style="font-size:20px;text-align:left;"><span style="font-family:'PingFangSC-Regular', 'PingFang SC', sans-serif;">&nbsp;&nbsp;&nbsp; updateMode ='append',</span></p><p style="font-size:20px;text-align:left;"><span style="font-family:'PingFangSC-Regular', 'PingFang SC', sans-serif;">&nbsp;&nbsp;&nbsp; enableKeyPartitions ='false',</span></p><p style="font-size:20px;text-align:left;"><span style="font-family:'PingFangSC-Regular', 'PingFang SC', sans-serif;">&nbsp;&nbsp;&nbsp; topicIsPattern ='false',</span></p><p style="font-size:20px;text-align:left;"><span style="font-family:'PingFangSC-Regular', 'PingFang SC', sans-serif;">&nbsp;&nbsp;&nbsp; parallelism ='1'</span></p><p style="font-size:20px;text-align:left;"><span style="font-family:'PingFangSC-Regular', 'PingFang SC', sans-serif;">&nbsp;);</span></p><p style="font-size:20px;text-align:left;"><span style="font-family:'PingFangSC-Regular', 'PingFang SC', sans-serif;font-size:25px;color:#EC808D;">示例：达梦 Table写法</span></p><p style="font-size:20px;text-align:left;"><span style="font-family:'PingFangSC-Regular', 'PingFang SC', sans-serif;">CREATE TABLE MyResult(</span></p><p style="font-size:20px;text-align:left;"><span style="font-family:'PingFangSC-Regular', 'PingFang SC', sans-serif;">&nbsp;&nbsp;&nbsp; NAME varchar,</span></p><p style="font-size:20px;text-align:left;"><span style="font-family:'PingFangSC-Regular', 'PingFang SC', sans-serif;">&nbsp;&nbsp;&nbsp; AGE int,</span></p><p style="font-size:20px;text-align:left;"><span style="font-family:'PingFangSC-Regular', 'PingFang SC', sans-serif;">&nbsp;&nbsp;&nbsp; COST int</span></p><p style="font-size:20px;text-align:left;"><span style="font-family:'PingFangSC-Regular', 'PingFang SC', sans-serif;">&nbsp;)WITH(</span></p><p style="font-size:20px;text-align:left;"><span style="font-family:'PingFangSC-Regular', 'PingFang SC', sans-serif;">&nbsp;&nbsp;&nbsp; type ='dameng',</span></p><p style="font-size:20px;text-align:left;"><span style="font-family:'PingFangSC-Regular', 'PingFang SC', sans-serif;">&nbsp;&nbsp;&nbsp; url =' jdbc:dm://10.15.0.52:5236/CSSFLINK',</span></p><p style="font-size:20px;text-align:left;"><span style="font-family:'PingFangSC-Regular', 'PingFang SC', sans-serif;">&nbsp;&nbsp;&nbsp; userName = 'CSSBASE',</span></p><p style="font-size:20px;text-align:left;"><span style="font-family:'PingFangSC-Regular', 'PingFang SC', sans-serif;">&nbsp;&nbsp;&nbsp; password = '1234567890',</span></p><p style="font-size:20px;text-align:left;"><span style="font-family:'PingFangSC-Regular', 'PingFang SC', sans-serif;">&nbsp;&nbsp;&nbsp; tableName = 'PERSON',</span></p><p style="font-size:20px;text-align:left;"><span style="font-family:'PingFangSC-Regular', 'PingFang SC', sans-serif;">&nbsp;&nbsp;&nbsp; updateMode ='insert',</span></p><p style="font-size:20px;text-align:left;"><span style="font-family:'PingFangSC-Regular', 'PingFang SC', sans-serif;">&nbsp;&nbsp;&nbsp; schema = 'CSSFLINK',</span></p><p style="font-size:20px;text-align:left;"><span style="font-family:'PingFangSC-Regular', 'PingFang SC', sans-serif;">&nbsp;&nbsp;&nbsp; parallelism = '1',</span></p><p style="font-size:20px;text-align:left;"><span style="font-family:'PingFangSC-Regular', 'PingFang SC', sans-serif;">&nbsp;&nbsp;&nbsp; batchSize = '100',</span></p><p style="font-size:20px;text-align:left;"><span style="font-family:'PingFangSC-Regular', 'PingFang SC', sans-serif;">&nbsp;&nbsp;&nbsp; batchWaitInterval = '1000'</span></p><p style="font-size:20px;text-align:left;"><span style="font-family:'PingFangSC-Regular', 'PingFang SC', sans-serif;">&nbsp;);</span></p><p style="font-size:20px;text-align:left;"><span style="font-family:'PingFangSC-Regular', 'PingFang SC', sans-serif;"><br></span></p>
        </div>
      </div>

      <!-- Unnamed (Rectangle) -->
      <div id="u79" class="ax_default button">
        <div id="u79_div" class=""></div>
        <div id="u79_text" class="text ">
          <p><span>？</span></p>
        </div>
      </div>

      <!-- Unnamed (Rectangle) -->
      <div id="u80" class="ax_default button ax_default_hidden" style="display:none; visibility: hidden">
        <div id="u80_div" class=""></div>
        <div id="u80_text" class="text ">
          <p><span>？</span></p>
        </div>
      </div>
    </div>
    <script src="resources/scripts/axure/ios.js"></script>
  </body>
</html>
